Tables [dbo].[Order_Lines]
SQLServer > iMIS1521GA > Tables > dbo.Order_Lines
Properties
PropertyValue
Created5:24:13 PM Wednesday, August 24, 2011
Last Modified3:22:18 PM Monday, February 20, 2012
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_Order_Lines: ORDER_NUMBER\LINE_NUMBERORDER_NUMBERnumeric(15,2)9
No
((0))
Cluster Primary Key PK_Order_Lines: ORDER_NUMBER\LINE_NUMBERLINE_NUMBERnumeric(15,2)9
No
((0))
Indexes iOrder_LinesPRODUCT_CODE: PRODUCT_CODE\LOCATION\LOT_SERIALPRODUCT_CODEvarchar(31)31
No
('')
Indexes iOrder_LinesPRODUCT_CODE: PRODUCT_CODE\LOCATION\LOT_SERIALLOCATIONvarchar(10)10
No
('')
Indexes iOrder_LinesPRODUCT_CODE: PRODUCT_CODE\LOCATION\LOT_SERIALLOT_SERIALvarchar(20)20
No
('')
DESCRIPTIONvarchar(255)255
No
('')
QUANTITY_ORDEREDnumeric(15,6)9
No
((0))
QUANTITY_SHIPPEDnumeric(15,6)9
No
((0))
QUANTITY_BACKORDEREDnumeric(15,6)9
No
((0))
QUANTITY_RESERVEDnumeric(15,6)9
No
((0))
QUANTITY_COMMITTEDnumeric(15,6)9
No
((0))
NUMBER_DAYSint4
No
((0))
TAXABLEbit1
No
((0))
TAXABLE_2bit1
No
((0))
UNIT_PRICEmoney8
No
((0))
UNIT_COSTmoney8
No
((0))
UNDISCOUNTED_PRICEmoney8
No
((0))
EXTENDED_AMOUNTmoney8
No
((0))
EXTENDED_COSTmoney8
No
((0))
UNDISCOUNTED_EXTENDED_AMOUNTmoney8
No
((0))
CANCEL_CODEvarchar(10)10
No
('')
CANCEL_QUANTITYnumeric(15,6)9
No
((0))
COMMISSION_RATEnumeric(15,4)9
No
((0))
COMMISSION_AMOUNTmoney8
No
((0))
CEU_TYPEvarchar(15)15
No
('')
CEU_AWARDEDnumeric(15,2)9
No
((0))
PASS_FAILvarchar(5)5
No
('')
DATE_CONFIRMEDdatetime8
Yes
TICKETS_PRINTEDint4
No
((0))
BOOTH_NUMBERSvarchar(255)255
No
('')
NOTEvarchar(255)255
Yes
INCOME_ACCOUNTvarchar(50)50
No
('')
UNIT_WEIGHTnumeric(15,2)9
No
((0))
EXTENDED_WEIGHTnumeric(15,2)9
No
((0))
PST_TAXABLEbit1
No
((0))
IS_GST_TAXABLEbit1
No
((0))
ADDED_TO_WAIT_LISTdatetime8
Yes
BINvarchar(10)10
No
('')
TAX_AUTHORITYvarchar(15)15
No
('')
TAX_RATEnumeric(15,4)9
No
((0))
TAX_1numeric(15,4)9
No
((0))
KIT_ITEM_TYPEtinyint1
No
((0))
DISCOUNTnumeric(15,2)9
No
((0))
UF_1varchar(30)30
No
('')
UF_2varchar(30)30
No
('')
UF_3varchar(30)30
No
('')
UF_4varchar(30)30
No
('')
EXTENDED_SQUARE_FEETnumeric(15,2)9
No
((0))
SQUARE_FEETnumeric(15,2)9
No
((0))
MEET_APPEALvarchar(40)40
No
('')
MEET_CAMPAIGNvarchar(10)10
No
('')
FAIR_MARKET_VALUEnumeric(15,2)9
No
((0))
ORG_CODEvarchar(5)5
No
('')
IS_FR_ITEMbit1
No
((0))
MANUAL_PRICEnumeric(15,2)9
No
((0))
IS_MANUAL_PRICEbit1
No
((0))
UNIT_TAX_AMOUNTnumeric(15,4)9
No
((0))
TIME_STAMPtimestamp8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_Order_Lines: ORDER_NUMBER\LINE_NUMBERPK_Order_LinesORDER_NUMBER, LINE_NUMBER
Yes
iOrder_LinesPRODUCT_CODEPRODUCT_CODE, LOCATION, LOT_SERIAL
Permissions
TypeActionOwning Principal
GrantDeleteIMIS
GrantInsertIMIS
GrantReferencesIMIS
GrantSelectIMIS
GrantUpdateIMIS
SQL Script
CREATE TABLE [dbo].[Order_Lines]
(
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_ORDER_NUMBER] DEFAULT ((0)),
[LINE_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_LINE_NUMBER] DEFAULT ((0)),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_PRODUCT_CODE] DEFAULT (''),
[LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_LOCATION] DEFAULT (''),
[LOT_SERIAL] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_LOT_SERIAL] DEFAULT (''),
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_DESCRIPTION] DEFAULT (''),
[QUANTITY_ORDERED] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_QUANTITY_ORDERED] DEFAULT ((0)),
[QUANTITY_SHIPPED] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_QUANTITY_SHIPPED] DEFAULT ((0)),
[QUANTITY_BACKORDERED] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_QUANTITY_BACKORDERED] DEFAULT ((0)),
[QUANTITY_RESERVED] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_QUANTITY_RESERVED] DEFAULT ((0)),
[QUANTITY_COMMITTED] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_QUANTITY_COMMITTED] DEFAULT ((0)),
[NUMBER_DAYS] [int] NOT NULL CONSTRAINT [DF_Order_Lines_NUMBER_DAYS] DEFAULT ((0)),
[TAXABLE] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_TAXABLE] DEFAULT ((0)),
[TAXABLE_2] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_TAXABLE_2] DEFAULT ((0)),
[UNIT_PRICE] [money] NOT NULL CONSTRAINT [DF_Order_Lines_UNIT_PRICE] DEFAULT ((0)),
[UNIT_COST] [money] NOT NULL CONSTRAINT [DF_Order_Lines_UNIT_COST] DEFAULT ((0)),
[UNDISCOUNTED_PRICE] [money] NOT NULL CONSTRAINT [DF_Order_Lines_UNDISCOUNTED_PRICE] DEFAULT ((0)),
[EXTENDED_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Order_Lines_EXTENDED_AMOUNT] DEFAULT ((0)),
[EXTENDED_COST] [money] NOT NULL CONSTRAINT [DF_Order_Lines_EXTENDED_COST] DEFAULT ((0)),
[UNDISCOUNTED_EXTENDED_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Order_Lines_UNDISCOUNTED_EXTENDED_AMOUNT] DEFAULT ((0)),
[CANCEL_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_CANCEL_CODE] DEFAULT (''),
[CANCEL_QUANTITY] [numeric] (15, 6) NOT NULL CONSTRAINT [DF_Order_Lines_CANCEL_QUANTITY] DEFAULT ((0)),
[COMMISSION_RATE] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Order_Lines_COMMISSION_RATE] DEFAULT ((0)),
[COMMISSION_AMOUNT] [money] NOT NULL CONSTRAINT [DF_Order_Lines_COMMISSION_AMOUNT] DEFAULT ((0)),
[CEU_TYPE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_CEU_TYPE] DEFAULT (''),
[CEU_AWARDED] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_CEU_AWARDED] DEFAULT ((0)),
[PASS_FAIL] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_PASS_FAIL] DEFAULT (''),
[DATE_CONFIRMED] [datetime] NULL,
[TICKETS_PRINTED] [int] NOT NULL CONSTRAINT [DF_Order_Lines_TICKETS_PRINTED] DEFAULT ((0)),
[BOOTH_NUMBERS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_BOOTH_NUMBERS] DEFAULT (''),
[NOTE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_INCOME_ACCOUNT] DEFAULT (''),
[UNIT_WEIGHT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_UNIT_WEIGHT] DEFAULT ((0)),
[EXTENDED_WEIGHT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_EXTENDED_WEIGHT] DEFAULT ((0)),
[PST_TAXABLE] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_PST_TAXABLE] DEFAULT ((0)),
[IS_GST_TAXABLE] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_IS_GST_TAXABLE] DEFAULT ((0)),
[ADDED_TO_WAIT_LIST] [datetime] NULL,
[BIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_BIN] DEFAULT (''),
[TAX_AUTHORITY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_TAX_AUTHORITY] DEFAULT (''),
[TAX_RATE] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Order_Lines_TAX_RATE] DEFAULT ((0)),
[TAX_1] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Order_Lines_TAX_1] DEFAULT ((0)),
[KIT_ITEM_TYPE] [tinyint] NOT NULL CONSTRAINT [DF_Order_Lines_KIT_ITEM_TYPE] DEFAULT ((0)),
[DISCOUNT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_DISCOUNT] DEFAULT ((0)),
[UF_1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_UF_1] DEFAULT (''),
[UF_2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_UF_2] DEFAULT (''),
[UF_3] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_UF_3] DEFAULT (''),
[UF_4] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_UF_4] DEFAULT (''),
[EXTENDED_SQUARE_FEET] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_EXTENDED_SQUARE_FEET] DEFAULT ((0)),
[SQUARE_FEET] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_SQUARE_FEET] DEFAULT ((0)),
[MEET_APPEAL] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_MEET_APPEAL] DEFAULT (''),
[MEET_CAMPAIGN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_MEET_CAMPAIGN] DEFAULT (''),
[FAIR_MARKET_VALUE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_FAIR_MARKET_VALUE] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Order_Lines_ORG_CODE] DEFAULT (''),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_IS_FR_ITEM] DEFAULT ((0)),
[MANUAL_PRICE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Order_Lines_MANUAL_PRICE] DEFAULT ((0)),
[IS_MANUAL_PRICE] [bit] NOT NULL CONSTRAINT [DF_Order_Lines_IS_MANUAL_PRICE] DEFAULT ((0)),
[UNIT_TAX_AMOUNT] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Order_Lines_UNIT_TAX_AMOUNT] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Order_Lines] ADD CONSTRAINT [PK_Order_Lines] PRIMARY KEY CLUSTERED ([ORDER_NUMBER], [LINE_NUMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iOrder_LinesPRODUCT_CODE] ON [dbo].[Order_Lines] ([PRODUCT_CODE], [LOCATION], [LOT_SERIAL]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Order_Lines] TO [IMIS]
GRANT SELECT ON  [dbo].[Order_Lines] TO [IMIS]
GRANT INSERT ON  [dbo].[Order_Lines] TO [IMIS]
GRANT DELETE ON  [dbo].[Order_Lines] TO [IMIS]
GRANT UPDATE ON  [dbo].[Order_Lines] TO [IMIS]
GO
Uses
Used By
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved